﻿using Lufei_CaterModel;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Lufei_CaterDAL
{
    public class R_Order_Desk_DAL
    {

        /// <summary>
        /// 往R_Roder_Desk插入订单数据
        /// </summary>
        /// <param name="r"></param>
        /// <returns></returns>
        public int InsertR_Roder_Desk(R_Order_Desk r)
        {
            string sql = "insert into R_Order_Desk(orderID,DeskID) values(@orderID,@deskID)";
            SQLiteParameter[] param = new SQLiteParameter[]
            {
                new SQLiteParameter("@orderID",r.OrderId),
                 new SQLiteParameter("@deskID",r.DeskId)
            };
           return SqlHelper.ExecuteNonQuery(sql, param);
        }

    }
}
